QUERY: select comp1.* from composition as comp1 where true and comp1.parent = 0 and comp1.arrangement_of = 0 and json_overlaps("[68]", comp1.instrument_combos->'$') and json_overlaps( (select json_arrayagg(person_role.id) from person_role join person on person.id = person_role.person where person_role.role=1 and person.id = 13595), comp1.creators->'$') order by comp1.long_title limit 0,51
| Title click for details |
Creators | Key | Opus | Composed | Instrumentation | Period/style | Type | Listen | Code |
|---|---|---|---|---|---|---|---|---|---|
| Do it Again! | George Gershwin, composer | F major (transposed?) | 1922 | voice and piano | Early 20th century | Songs | |||
| Drifting Along with the Tide | George Gershwin, composer | G major | 1921 | voice and piano | Early 20th century | Songs | |||
| I Was So Young (You Were So Beautiful) | George Gershwin, composer | G major | 1919 | voice and piano | Early 20th century | Songs | |||
| Idle Dreams | George Gershwin, composer Arthur Jackson, librettist |
G major | 1920 | voice and piano | Early 20th century | Songs | |||
| Scandal Walk | George Gershwin, composer | E major (transposed?) | voice and piano | Early 20th century | Songs | ||||
| Someone to Watch Over Me | George Gershwin, composer Ira Gershwin, librettist |
E flat major | voice and piano | Early 20th century | Songs | ||||
| Swanee | George Gershwin, composer | F minor/major | 1919 | voice and piano | Early 20th century | Songs | ![]() |
||
| The Man I Love | George Gershwin, composer | 1924 | voice and piano | Early 20th century | Songs | ||||
| The Yankee Doodle Blues | George Gershwin, composer Irving Caesar, librettist B. G. De Sylva, librettist |
voice and piano | Early 20th century | Blues, Songs |
©2026 CMI